<!--

     Licensed to the Apache Software Foundation (ASF) under one
     or more contributor license agreements.  See the NOTICE file
     distributed with this work for additional information
     regarding copyright ownership.  The ASF licenses this file
     to you under the Apache License, Version 2.0 (the
     "License"); you may not use this file except in compliance
     with the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

     Unless required by applicable law or agreed to in writing,
     software distributed under the License is distributed on an
     "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
     KIND, either express or implied.  See the License for the
     specific language governing permissions and limitations
     under the License.

-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- **************************************************************** -->
<!-- *  PLEASE KEEP COMPLICATED EXPRESSIONS OUT OF THESE TEMPLATES, * -->
<!-- *  i.e. only iterate & print data where possible. Thanks, Jez. * -->
<!-- **************************************************************** -->

<html>
<head>
    <!-- Generated by groovydoc (2.4.5) on Mon Sep 12 08:35:24 CEST 2016 -->
    <title>SQLConnection (Groovy Documentation)</title>
    <meta name="date" content="2016-09-12">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="../../../../../groovy.ico" type="image/x-icon" rel="shortcut icon">
    <link href="../../../../../groovy.ico" type="image/x-icon" rel="icon">
    <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">

<body class="center">
<script type="text/javascript"><!--
if (location.href.indexOf('is-external=true') == -1) {
    parent.document.title="SQLConnection (Groovy Documentation)";
}
//-->
</script>
<noscript>
    <div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
    <!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
    <!--   -->
</a>
    <ul class="navList" title="Navigation">
        <li><a href="../../../../../overview-summary.html">Overview</a></li>
        <li><a href="package-summary.html">Package</a></li>
        <li class="navBarCell1Rev">Class</li>
        <li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
        <li><a href="../../../../../index-all.html">Index</a></li>
        <li><a href="../../../../../help-doc.html">Help</a></li>
    </ul>
</div>

<div class="subNav">
    <div>
        <ul class="navList">
            <li><a href="../../../../../index.html?io/vertx/groovy/ext/sql/SQLConnection" target="_top">Frames</a></li>
            <li><a href="SQLConnection.html" target="_top">No Frames</a></li>
        </ul>
    </div>
    <div>
        <ul class="subNavList">
            <li>Summary:&nbsp;</li>
            Nested&nbsp;&nbsp;&nbsp;Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#constructor_summary">Constructor</a></li>&nbsp;&nbsp;&nbsp;<li><a href="#method_summary">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
        <ul class="subNavList">
            <li>&nbsp;|&nbsp;Detail:&nbsp;</li>
            Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#constructor_detail">Constructor</a></li>&nbsp;&nbsp;&nbsp;<li><a href="#method_detail">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
    </div>
    <a name="skip-navbar_top">
        <!--   -->
    </a></div>
<!-- ========= END OF TOP NAVBAR ========= -->

<!-- ======== START OF CLASS DATA ======== -->
<div class="header">

    <div class="subTitle">Package: <strong>io.vertx.groovy.ext.sql</strong></div>

    <h2 title="[Groovy] Class SQLConnection" class="title">[Groovy] Class SQLConnection</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li><ul class="inheritance"></ul></li><li>io.vertx.groovy.ext.sql.SQLConnection
</ul>
<div class="description">
    <ul class="blockList">
        <li class="blockList">



    <p> Represents a connection to a SQL database
</p>

          </li>
    </ul>
</div>

<div class="summary">
    <ul class="blockList">
        <li class="blockList">
        <!-- =========== NESTED CLASS SUMMARY =========== -->
        

        <!-- =========== ENUM CONSTANT SUMMARY =========== -->
        
        <!-- =========== FIELD SUMMARY =========== -->
        

        <!-- =========== PROPERTY SUMMARY =========== -->
        

        <!-- =========== ELEMENT SUMMARY =========== -->
        

        
        <!-- ======== CONSTRUCTOR SUMMARY ======== -->
        <ul class="blockList">
                <li class="blockList"><a name="constructor_summary"><!--   --></a>
                    <h3>Constructor Summary</h3>
                    <ul class="blockList">
                    <table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructors Summary table">
                        <caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
                        <tr>
                            <th class="colFirst" scope="col">Constructor and description</th>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst">
                                <code><a href="#SQLConnection(java.lang.Object)">SQLConnection</a></strong>
                                (java.lang.Object delegate)</code><br></td>
                        </tr>
                        
                    </table>
                   </ul>
              </li>
        </ul>
        

        
        <!-- ========== METHOD SUMMARY =========== -->
        <ul class="blockList">
            
            <li class="blockList"><a name="method_summary"><!--   --></a>
                    <h3>Methods Summary</h3>
                    <ul class="blockList">
                    <table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Methods Summary table">
                        <caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
                        <tr>
                            <th class="colFirst" scope="col">Type</th>
                            <th class="colLast" scope="col">Name and description</th>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#batch(List<String>, Handler<AsyncResult<List<Integer>>>)">batch</a></strong>(java.util.List&lt;java.lang.String&gt; sqlStatements, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</code><br>Batch simple SQL strings and execute the batch where the async result contains a array of Integers.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#batchCallableWithParams(java.lang.String, List<List<Object>>, List<List<Object>>, Handler<AsyncResult<List<Integer>>>)">batchCallableWithParams</a></strong>(java.lang.String sqlStatement, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; inArgs, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; outArgs, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</code><br>Batch a callable statement with all entries from the args list. </td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#batchWithParams(java.lang.String, List<List<Object>>, Handler<AsyncResult<List<Integer>>>)">batchWithParams</a></strong>(java.lang.String sqlStatement, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; args, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</code><br>Batch a prepared statement with all entries from the args list. </td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#call(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)">call</a></strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Calls the given SQL <code>PROCEDURE</code> which returns the result from the procedure.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#callWithParams(java.lang.String, List<Object>, List<Object>, Handler<AsyncResult<Map<String, Object>>>)">callWithParams</a></strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, java.util.List&lt;java.lang.Object&gt; outputs, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Calls the given SQL <code>PROCEDURE</code> which returns the result from the procedure.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code>void</strong></code></td>
                            <td class="colLast"><code><strong><a href="#close(Handler<AsyncResult<Void>>)">close</a></strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</code><br>Closes the connection. </td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>void</strong></code></td>
                            <td class="colLast"><code><strong><a href="#close()">close</a></strong>()</code><br>Closes the connection. </td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#commit(Handler<AsyncResult<Void>>)">commit</a></strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</code><br>Commits all changes made since the previous commit/rollback.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#execute(java.lang.String, Handler<AsyncResult<Void>>)">execute</a></strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; resultHandler)</code><br>Executes the given SQL statement</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code>java.lang.Object</strong></code></td>
                            <td class="colLast"><code><strong><a href="#getDelegate()">getDelegate</a></strong>()</code><br></td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#getTransactionIsolation(Handler<AsyncResult<TransactionIsolation>>)">getTransactionIsolation</a></strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;io.vertx.ext.sql.TransactionIsolation&gt;&gt; handler)</code><br>Attempts to return the transaction isolation level for this Connection object to the one given.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#query(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)">query</a></strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Executes the given SQL <code>SELECT</code> statement which returns the results of the query.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#queryWithParams(java.lang.String, List<Object>, Handler<AsyncResult<Map<String, Object>>>)">queryWithParams</a></strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Executes the given SQL <code>SELECT</code> prepared statement which returns the results of the query.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#rollback(Handler<AsyncResult<Void>>)">rollback</a></strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</code><br>Rolls back all changes made since the previous commit/rollback.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#setAutoCommit(boolean, Handler<AsyncResult<Void>>)">setAutoCommit</a></strong>(boolean autoCommit, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; resultHandler)</code><br>Sets the auto commit flag for this connection. </td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#setQueryTimeout(int)">setQueryTimeout</a></strong>(int timeoutInSeconds)</code><br>Sets a connection wide query timeout.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#setTransactionIsolation(io.vertx.ext.sql.TransactionIsolation, Handler<AsyncResult<Void>>)">setTransactionIsolation</a></strong>(io.vertx.ext.sql.TransactionIsolation isolation, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</code><br>Attempts to change the transaction isolation level for this Connection object to the one given.</td>
                        </tr>
                        
                        <tr class="rowColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#update(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)">update</a></strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Executes the given SQL statement which may be an <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code>
 statement.</td>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a></strong></code></td>
                            <td class="colLast"><code><strong><a href="#updateWithParams(java.lang.String, List<Object>, Handler<AsyncResult<Map<String, Object>>>)">updateWithParams</a></strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</code><br>Executes the given prepared statement which may be an <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code>
 statement with the given parameters</td>
                        </tr>
                        
                    </table>
                   </ul>
              </li>
            
            <li class="blockList"><a name="method_summary"><!--   --></a>
                    <h3>Inherited Methods Summary</h3>
                    <ul class="blockList">
                    <table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Inherited Methods Summary table">
                        <caption><span>Inherited Methods</span><span class="tabEnd">&nbsp;</span></caption>
                        <tr>
                            <th class="colFirst" scope="col">Methods inherited from class</th>
                            <th class="colLast" scope="col">Name</th>
                        </tr>
                        
                        <tr class="altColor">
                            <td class="colFirst"><code>class java.lang.Object</strong></code></td>
                            <td class="colLast"><code>java.lang.Object#wait(long, int), java.lang.Object#wait(long), java.lang.Object#wait(), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll()</code></td>
                        </tr>
                    </table>
                   </ul>
              </li>
                
        </ul>
        
    </li>
    </ul>
</div>

<div class="details">
    <ul class="blockList">
        <li class="blockList">
           

            

            

            

            
            <!-- =========== CONSTRUCTOR DETAIL =========== -->
            <ul class="blockList">
                <li class="blockList"><a name="constructor_detail">
                    <!--   -->
                </a>
                    <h3>Constructor Detail</h3>
                    
                        <a name="SQLConnection(java.lang.Object)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><strong>SQLConnection</strong>(java.lang.Object delegate)</h4>
                                <p></p>
                            </li>
                        </ul>
                    
                </li>
            </ul>
            


            
            <!-- =========== METHOD DETAIL =========== -->
            <ul class="blockList">
                <li class="blockList"><a name="method_detail">
                    <!--   -->
                </a>
                    <h3>Method Detail</h3>
                    
                        <a name="batch(List<String>, Handler<AsyncResult<List<Integer>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>batch</strong>(java.util.List&lt;java.lang.String&gt; sqlStatements, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</h4>
                                <p> Batch simple SQL strings and execute the batch where the async result contains a array of Integers. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sqlStatements</code> -  sql statement</DD><DD><code>handler</code> -  the result handler</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="batchCallableWithParams(java.lang.String, List<List<Object>>, List<List<Object>>, Handler<AsyncResult<List<Integer>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>batchCallableWithParams</strong>(java.lang.String sqlStatement, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; inArgs, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; outArgs, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</h4>
                                <p> Batch a callable statement with all entries from the args list. Each entry is a batch.
 The size of the lists inArgs and outArgs MUST be the equal.
 The operation completes with the execution of the batch where the async result contains a array of Integers. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sqlStatement</code> -  sql statement</DD><DD><code>inArgs</code> -  the callable statement input arguments</DD><DD><code>outArgs</code> -  the callable statement output arguments</DD><DD><code>handler</code> -  the result handler</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="batchWithParams(java.lang.String, List<List<Object>>, Handler<AsyncResult<List<Integer>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>batchWithParams</strong>(java.lang.String sqlStatement, java.util.List&lt;java.util.List&lt;java.lang.Object&gt;&gt; args, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.List&lt;java.lang.Integer&gt;&gt;&gt; handler)</h4>
                                <p> Batch a prepared statement with all entries from the args list. Each entry is a batch.
 The operation completes with the execution of the batch where the async result contains a array of Integers. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sqlStatement</code> -  sql statement</DD><DD><code>args</code> -  the prepared statement arguments</DD><DD><code>handler</code> -  the result handler</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="call(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>call</strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Calls the given SQL <code>PROCEDURE</code> which returns the result from the procedure. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>{call getEmpName (?, ?)}</code>.</DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes. It will return a <code>ResultSet</code>.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="callWithParams(java.lang.String, List<Object>, List<Object>, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>callWithParams</strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, java.util.List&lt;java.lang.Object&gt; outputs, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Calls the given SQL <code>PROCEDURE</code> which returns the result from the procedure.

 The index of params and outputs are important for both arrays, for example when dealing with a prodecure that
 takes the first 2 arguments as input values and the 3 arg as an output then the arrays should be like:

 <pre>
   params = [VALUE1, VALUE2, null]
   outputs = [null, null, "VARCHAR"]
 </pre> <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>{call getEmpName (?, ?)}</code>.</DD><DD><code>params</code> -  these are the parameters to fill the statement.</DD><DD><code>outputs</code> -  these are the outputs to fill the statement.</DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes. It will return a <code>ResultSet</code>.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="close(Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>void <strong>close</strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</h4>
                                <p> Closes the connection. Important to always close the connection when you are done so it's returned to the pool.
   <DL><DT><B>Parameters:</B></DT><DD><code>handler</code> -  the handler called when this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="close()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>void <strong>close</strong>()</h4>
                                <p> Closes the connection. Important to always close the connection when you are done so it's returned to the pool.
   </p>
                            </li>
                        </ul>
                    
                        <a name="commit(Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>commit</strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</h4>
                                <p> Commits all changes made since the previous commit/rollback. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>handler</code> -  the handler called when this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="execute(java.lang.String, Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>execute</strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; resultHandler)</h4>
                                <p> Executes the given SQL statement <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>CREATE TABLE IF EXISTS table ...</code></DD><DD><code>resultHandler</code> -  the handler which is called once this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="getDelegate()"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4>java.lang.Object <strong>getDelegate</strong>()</h4>
                                <p></p>
                            </li>
                        </ul>
                    
                        <a name="getTransactionIsolation(Handler<AsyncResult<TransactionIsolation>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>getTransactionIsolation</strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;io.vertx.ext.sql.TransactionIsolation&gt;&gt; handler)</h4>
                                <p> Attempts to return the transaction isolation level for this Connection object to the one given. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>handler</code> -  the handler called when this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="query(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>query</strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Executes the given SQL <code>SELECT</code> statement which returns the results of the query. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>SELECT * FROM table ...</code>.</DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes. It will return a <code>ResultSet</code>.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="queryWithParams(java.lang.String, List<Object>, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>queryWithParams</strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Executes the given SQL <code>SELECT</code> prepared statement which returns the results of the query. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>SELECT * FROM table ...</code>.</DD><DD><code>params</code> -  these are the parameters to fill the statement.</DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes. It will return a <code>ResultSet</code>.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="rollback(Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>rollback</strong>(io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</h4>
                                <p> Rolls back all changes made since the previous commit/rollback. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>handler</code> -  the handler called when this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="setAutoCommit(boolean, Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>setAutoCommit</strong>(boolean autoCommit, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; resultHandler)</h4>
                                <p> Sets the auto commit flag for this connection. True by default. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>autoCommit</code> -  the autoCommit flag, true by default.</DD><DD><code>resultHandler</code> -  the handler which is called once this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="setQueryTimeout(int)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>setQueryTimeout</strong>(int timeoutInSeconds)</h4>
                                <p> Sets a connection wide query timeout.

 It can be over written at any time and becomes active on the next query call. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>timeoutInSeconds</code> -  the max amount of seconds the query can take to execute.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="setTransactionIsolation(io.vertx.ext.sql.TransactionIsolation, Handler<AsyncResult<Void>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>setTransactionIsolation</strong>(io.vertx.ext.sql.TransactionIsolation isolation, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.lang.Void&gt;&gt; handler)</h4>
                                <p> Attempts to change the transaction isolation level for this Connection object to the one given.

 The constants defined in the interface Connection are the possible transaction isolation levels. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>isolation</code> -  the level of isolation</DD><DD><code>handler</code> -  the handler called when this operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="update(java.lang.String, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>update</strong>(java.lang.String sql, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Executes the given SQL statement which may be an <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code>
 statement. <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>INSERT INTO table ...</code></DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                        <a name="updateWithParams(java.lang.String, List<Object>, Handler<AsyncResult<Map<String, Object>>>)"><!-- --></a>
                        <ul class="blockListLast">
                            <li class="blockList">
                                <h4><a href='../../../../../io/vertx/groovy/ext/sql/SQLConnection.html'>SQLConnection</a> <strong>updateWithParams</strong>(java.lang.String sql, java.util.List&lt;java.lang.Object&gt; params, io.vertx.core.Handler&lt;io.vertx.core.AsyncResult&lt;java.util.Map&lt;java.lang.String, java.lang.Object&gt;&gt;&gt; resultHandler)</h4>
                                <p> Executes the given prepared statement which may be an <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code>
 statement with the given parameters <DL><DT><B>Returns:</B></DT><DD></DD></DL><DL><DT><B>Parameters:</B></DT><DD><code>sql</code> -  the SQL to execute. For example <code>INSERT INTO table ...</code></DD><DD><code>params</code> -  these are the parameters to fill the statement.</DD><DD><code>resultHandler</code> -  the handler which is called once the operation completes.</DD></DL></p>
                            </li>
                        </ul>
                    
                </li>
            </ul>
            
        </li>
    </ul>
</div>

<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
    <!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
    <!--   -->
</a>
    <ul class="navList" title="Navigation">
        <li><a href="../../../../../overview-summary.html">Overview</a></li>
        <li><a href="package-summary.html">Package</a></li>
        <li class="navBarCell1Rev">Class</li>
        <li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
        <li><a href="../../../../../index-all.html">Index</a></li>
        <li><a href="../../../../../help-doc.html">Help</a></li>
    </ul>
</div>

<div class="subNav">
    <div>
        <ul class="navList">
            <li><a href="../../../../../index.html?io/vertx/groovy/ext/sql/SQLConnection" target="_top">Frames</a></li>
            <li><a href="SQLConnection.html" target="_top">No Frames</a></li>
        </ul>
    </div>
    <div>
        <ul class="subNavList">
            <li>Summary:&nbsp;</li>
            Nested&nbsp;&nbsp;&nbsp;Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#constructor_summary">Constructor</a></li>&nbsp;&nbsp;&nbsp;<li><a href="#method_summary">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
        <ul class="subNavList">
            <li>&nbsp;|&nbsp;Detail:&nbsp;</li>
            Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li><a href="#constructor_detail">Constructor</a></li>&nbsp;&nbsp;&nbsp;<li><a href="#method_detail">Method</a></li>&nbsp;&nbsp;&nbsp;
        </ul>
    </div>
    <p>Groovy Documentation</p>
    <a name="skip-navbar_bottom">
        <!--   -->
    </a>
    </div>
</div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</body>
</html>